Skip Headers

Oracle® Database Heterogeneous Connectivity Administrator's Guide 10g Release 2 (10.2) Part Number B14232-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I L M O P Q R S T U V

## A

  agent control utility. See agtctl.
  agents
    Generic Connectivity, 2.3.2
    Heterogeneous Services
      architecture, 2.1
      disabling self-registration, 4.4.2
      registering, 4.4, 4.4.1, 4.4.1.1, 4.4.1.2
      types of agents, 2.3
    multithreaded Heterogeneous Services, 5
    specifying initialization parameters for, 4.1.2
    Transparent Gateways, 2.3.1
  agtctl, 5.2, 5.3
    commands, 5.3.1
    shell mode commands, 5.3.3
    single-line command mode, 5.3.2
  application development
    Heterogeneous Services
      controlling array fetches between non-Oracle server and agent, 4.3.3
      controlling array fetches between Oracle server and agent, 4.3.2
      controlling reblocking of array fetches, 4.3.4
      DBMS_HS_PASSTHROUGH package, 3.3
      pass-through SQL, 3.3
      using bulk fetches, 4.3
      using OCI for bulk fetches, 4.3.1
  array fetches, 4.3.1
    agents, 4.3.3

## B

  bind queries
    executing using pass-through SQL, 3.3.3.2
  BIND_INOUT_VARIABLE procedure, 3.3.3, 3.3.3.1.4
  BIND_OUT_VARIABLE procedure, 3.3.3, 3.3.3.1.3
  BIND_VARIABLE procedure, 3.3.3
  buffers
    multiple rows, 3.3.3.2
  bulk fetches
    optimizing data transfers using, 4.3

## C

  callback link, 3.10.2
  character sets
    Heterogeneous Services, A.11.1
  CLOSE_CURSOR function, 3.3.3
  commit point site
    commit point strength, A.2
  configuring
    Generic Connectivity, 7.3
    Transparent Gateways, 4.1
  copying data
    from Oracle database server to SQL Server, 4.8
    from SQL Server to Oracle database server, 4.9
    INSERT statement, 4.9

## D

  data dictionary
    contents with Generic Connectivity, C.3
    mapping for Generic Connectivity, C.3.1
    Oracle server name/SQL Server name, C.3.1
    translation support for Generic Connectivity, C
  data dictionary views
    Generic Connectivity, C.3
    Heterogeneous Services, 4.10, C.2
  data type checking support
    for remote-mapped statements, 4.5.1
  database links
    heterogeneous systems, 4.1.2
  date formats
    Heterogeneous Services, A.13, A.17
  DBMS_HS_PASSTHROUGH package, 3.3.1
    list of functions and procedures, 3.3.3
  describe cache high water mark
    definition, A.6
  dispatcher threads
    multithreaded Heterogeneous Services agents, 5.2, 5.2.2
  distributed queries
    optimizing performance, 6.2
  drivers
    ODBC, 7.4
    OLE DB (FS), 7.6
    OLE DB (SQL), 7.5
  dynamic performance views
    Heterogeneous Services, 4.11
      determining open sessions, 4.11.2
      determining which agents are on host, 4.11.1

## E

  EXECUTE_IMMEDIATE procedure, 3.3.3
    restrictions, 3.3.3.1
  EXECUTE_NON_QUERY procedure, 3.3.3

## F

  FDS_CLASS, 4.4.1.2.1
  FDS_CLASS_VERSION, 4.4.1.2.1
  FDS_INST_NAME, 4.4.1.2.2
  features
    new, Preface
  FETCH_ROW procedure, 3.3.3
    executing queries using pass-through SQL, 3.3.3.2
  fetches
    bulk, 4.3
    optimizing round-trips, 3.3.3.2

## G

  gateways
    how they work, 2.7
  Generic Connectivity
    architecture, 7.1.2
      Oracle and non-Oracle on same machine, 7.1.2.2
      Oracle and non-Oracle on separate machines, 7.1.2.1
    configuration, 7.3
    creating initialization file, 7.3.1
    data dictionary
      translation support, C
    defined, 1.2
    definition, 7.1
    DELETE statement, 7.2
    editing initialization file, 7.3.2
    Heterogeneous Services, 2.3.2
    INSERT statement, 7.2
    non-Oracle data dictionary access, C.1
    ODBC connectivity requirements, 7.4
    OLE DB (FS) connectivity requirements, 7.6
    OLE DB (SQL) connectivity requirements, 7.5
    restrictions, 7.1.5
    setting parameters for ODBC source, 7.3.3
      UNIX, 7.3.3.2
      Windows NT, 7.3.3.1
    setting parameters for OLE DB source, 7.3.4
    SQL execution, 7.1.3
    supported functions, 7.2
    supported SQL syntax, 7.2
    types of agents, 7.1.1
    UPDATE statement, 7.2
  generic connectivity
    error tracing, A.10
  GET_VALUE procedure, 3.3.3, 3.3.3.1.3, 3.3.3.1.4
  globalization support
    Heterogeneous Services, A.11
      character set of non-Oracle source, A.15
      date format, A.13
      languages in character date values, A.14

## H

  heterogeneous distributed systems
    accessing, 4.1
  Heterogeneous Services
    agent control utility (agtctl), 5.3.1
    agent registration, 4.4
      avoiding configuration mismatches, 4.4.1.1
      disabling, 4.4.2
      enabling, 4.4.1
      self-registration, 4.4.1.2
    application development
      controlling array fetches between non-Oracle server and agent, 4.3.3
      controlling array fetches between Oracle server and agent, 4.3.2
      controlling reblocking of array fetches, 4.3.4
      DBMS_HS_PASSTHROUGH package, 3.3
      pass-through SQL, 3.3
      using bulk fetches, 4.3
      using OCI for bulk fetches, 4.3.1
    creating database links, 4.1.2
    data dictionary views, 4.10, C.2
      types, 4.10.1
      understanding sources, 4.10.2
      using general views, 4.10.3
      using SQL service views, 4.10.5
      using transaction service views, 4.10.4
    defining maximum number of open cursors, A.19
    dynamic performance views, 4.11
      V$HS_AGENT view, 4.11.1
      V$HS_SESSION view, 4.11.2
    Generic Connectivity
      architecture, 7.1.2
      creating initialization file, 7.3.1
      definition, 7.1
      editing initialization file, 7.3.2
      non-Oracle data dictionary access, C.1
      ODBC connectivity requirements, 7.4
      OLE DB (FS) connectivity requirements, 7.6
      OLE DB (SQL) connectivity requirements, 7.5
      restrictions, 7.1.5
      setting parameters for ODBC source, 7.3.3
      setting parameters for OLE DB source, 7.3.4
      SQL execution, 7.1.3
      supported functions, 7.2
      supported SQL syntax, 7.2
      supported tables, C.3
      types of agents, 7.1.1
    initialization parameters, 2.5.2, 4.2, 7.3.1, A
    multithreaded agents, 5
    optimizing data transfer, A.21
    setting global name, A.5
    setting up access using Transparent Gateway, 4.1
    setting up environment, 4.1.1
    specifying cache high water mark, A.6
    specifying cache size, A.20
    specifying commit point strength, A.2
    SQL service, 2.4.2
    testing connections, 4.1.3
    transaction service, 2.4.1
    tuning internal data buffering, A.22
    tuning LONG data transfer, A.12
  HS_AUTOREGISTER initialization parameter
    using to enable agent self-registration, 4.4.1.3
  HS_BASE_CAPS view, 4.10.1
  HS_BASE_DD view, 4.10.1
  HS_CALL_NAME initialization parameter, A.1
  HS_CLASS_CAPS view, 4.10.1
  HS_CLASS_DD view, 4.10.1
  HS_CLASS_INIT view, 4.10.1
  HS_COMMIT_POINT_STRENGTH initialization parameter, A.2
  HS_DB_NAME initialization parameter, A.5
  HS_DESCRIBE_CACHE_HWM initialization parameter, A.6
  HS_FDS_CLASS view, 4.10.1
  HS_FDS_CONNECT_INFO initialization parameter, A.7
    specifying connection information, 7.3.2
  HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter, A.8
  HS_FDS_FETCH_ROWS initialization parameter, 4.3.3
  HS_FDS_INST view, 4.10.1
  HS_FDS_SHAREABLE_NAME initialization parameter, A.9
  HS_FDS_TRACE_LEVEL initialization parameter, A.10
    enabling agent tracing, 7.3.2
  HS_INST_CAPS view, 4.10.1
  HS_INST_DD view, 4.10.1
  HS_INST_INIT view, 4.10.1
  HS_LANGUAGE initialization parameter, A.11
  HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, A.12
  HS_NLS_DATE_FORMAT initialization parameter, A.13
  HS_NLS_DATE_LANGUAGE initialization parameter, A.14
  HS_NLS_NCHAR initialization parameter, A.15
  HS_NLS_NUMERIC_CHARACTER initialization parameter, A.16
  HS_NLS_TIMESTAMP_FORMAT initialization parameter, A.17
  HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter, A.18
  HS_OPEN_CURSORS initialization parameter, A.19
  HS_ROWID_CACHE_SIZE initialization parameter, A.20
  HS_RPC_FETCH_REBLOCKING initialization parameter, 4.3.4, A.21
  HS_RPC_FETCH_SIZE initialization parameter, 4.3.2, 4.3.4, A.22
  HS_TIME_ZONE initialization parameter, A.23

## I

  IFILE initialization parameter, A.24
  information integration
    benefits of Oracle solutions, 1.3
    challenges, 1.1
    Generic Connectivity, 1.2
    how Oracle addresses, 1.2
    Messaging Gateway, 1.2
    Open System Interfaces, 1.2
    Oracle Streams, 1.2
    Oracle Transparent Gateways, 1.2
  initialization parameters
    Heterogeneous Services (HS), 2.5.2, 4.2, 7.3.1, A
  initialization parameters (HS)
    common to all gateways, 4.2
    descriptions, A
    Generic Connectivity, 7.3.1
    purpose, 2.5.2

## L

  listeners, 4.1.1

## M

  Messaging Gateway
    defined, 1.2
  monitor thread
    multithreaded Heterogeneous Services agents, 5.2, 5.2.1
  multiple rows
    buffering, 3.3.3.2
  multithreaded Heterogeneous Services agents
    administering, 5.3
    advantages, 5.1.2
    agent control utility (agtctl), 5.3.1
    architecture, 5.2
    configuration parameters, 5.3.4
    dispatcher threads, 5.2, 5.2.2
    monitor thread, 5.2, 5.2.1
    task threads, 5.2, 5.2.3

## O

  OCI
    optimizing data transfers using, 4.3.1
  ODBC agents
    connectivity requirements, 7.4
    functions, 7.4
  ODBC connectivity
    data dictionary mapping, C.3.1
    ODBC driver, 7.4
    requirements, 7.4
    specifying connection information
      UNIX, A.7.2
      Windows NT, A.7.1
    specifying path to library, A.9
  OLE DB (FS) drivers, 7.6
  OLE DB (SQL) drivers, 7.5
  OLE DB agents
    connectivity requirements, 7.5, 7.6
  OLE DB connectivity
    data dictionary mapping, C.3.1
    setting connection information, A.7.3
  OLE DB drivers
    data provider requirements, 7.6.1
    initialization properties, 7.6.2
    rowset properties, 7.6.2
  Open System Interfaces
    defined, 1.2
  OPEN_CURSOR procedure, 3.3.3
  Oracle database server
    SQL construct processing, 4.5
  Oracle Net Services listener, 2.2, 4.1.1
  Oracle precompiler
    optimizing data transfers using, 4.3.1
  Oracle Streams
    defined, 1.2
  Oracle Transparent Gateways
    defined, 1.2
    optimizing SQL statements, 6.1
  OUT bind variables, 3.3.3.1.3

## P

  PARSE procedure, 3.3.3
  pass-through SQL
    avoiding SQL interpretation, 3.3
    executing statements, 3.3.3
      non-queries, 3.3.3.1
      queries, 3.3.3.2
      with bind variables, 3.3.3.1.1
      with IN bind variables, 3.3.3.1.2
      with IN OUT bind variables, 3.3.3.1.4
      with OUT bind variables, 3.3.3.1.3
    implications of using, 3.3.2
    overview, 3.3
    restrictions, 3.3.2

## Q

  queries
    pass-through SQL, 3.3.3.2

## R

  reblocking, 4.3.4
  remote functions
    referenced in SQL statements, A.1
  remote-mapped statements
    and data type checking support, 4.5.1
  rows
    buffering multiple, 3.3.3.2

## S

  SELECT statement
    accessing non-Oracle system, C.1
  service names
    specifying in database links, 4.1.2
  SQL capabilities
    data dictionary tables, 4.10.5.1
  SQL service
    data dictionary views, 2.6.2, 4.10.1
    Heterogeneous Services, 2.4.2
    views
      Heterogeneous Services, 4.10.5
  SQL statements
    optimizing distributed, 6.1
  Streams
    using for heterogeneous connectivity, 3.2
  Synonyms, 4.7

## T

  task threads
    multithreaded Heterogeneous Services agents, 5.2, 5.2.3
  transaction service
    Heterogeneous Services, 2.4.1
    views
      Heterogeneous Services, 4.10.4
  transparent gateways
    accessing Heterogeneous Services agents, 4.1.1
    creating database links, 4.1.2
    testing connections, 4.1.3

## U

  unsupported functions
    Generic Connectivity, 7.2
  user-defined functions
    executing on non-Oracle database, 4.6

## V

  variables
    bind, 3.3.3.1.1